package com.luchao.ptz.repository;

import com.luchao.ptz.pojo.PwTmsgs;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface PwTmsgsRepository extends JpaRepository<PwTmsgs, Long> {

    @Query(value = "SELECT * FROM pw_tmsgs ORDER BY tid DESC", nativeQuery = true)
    List<PwTmsgs> getAll();
}
